IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[cms_sp_UserGroupSelectOne]') AND type in (N'P', N'PC'))
	DROP PROCEDURE [dbo].[cms_sp_UserGroupSelectOne]
GO
create procedure [dbo].[cms_sp_UserGroupSelectOne]
@Id int
as
select [UserGroupId] as Id,
      [SiteId],
      [SiteGroupId],
      [GroupName],
      [IsEnabled],
      [IsSystem],
      [CreatedBy],
      [DateCreated],
      [LastUpdatedBy],
      [DateLastUpdated]
from [dbo].[UserGroups]
where [UserGroupId] = @Id


GO

